/*
MySQL Backup
Database: ai
Backup Time: 2023-09-22 03:44:18
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `ai`.`balance`;
DROP TABLE IF EXISTS `ai`.`interface`;
DROP TABLE IF EXISTS `ai`.`packagelist`;
DROP TABLE IF EXISTS `ai`.`userinfo`;
CREATE TABLE `balance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `Account` varchar(255) DEFAULT NULL COMMENT '账号\r\n',
  `money` varchar(255) DEFAULT NULL COMMENT '金额',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `completeTime` datetime DEFAULT NULL COMMENT '完成时间',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '充值类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `interface` (
  `id` int NOT NULL AUTO_INCREMENT,
  `interface` varchar(255) DEFAULT NULL,
  `receive` varchar(3000) DEFAULT NULL,
  `return` varchar(3000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `packagelist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` text,
  `money` varchar(255) DEFAULT NULL,
  `PayList` varchar(255) DEFAULT NULL,
  `types` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `businessid` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
CREATE TABLE `userinfo` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户名\r\n',
  `Account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
  `paswrod` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码\r\n',
  `creatTime` datetime NOT NULL COMMENT '注册时间',
  `status` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '状态:1:正常 3:冻结 4:封号',
  `token` varchar(600) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密钥\r\n',
  `phoneNumber` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '手机号',
  `imageUrl` text COMMENT '用户头像\r\n',
  `Paintbalance` int DEFAULT '0',
  `Chatbalance` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
BEGIN;
LOCK TABLES `ai`.`balance` WRITE;
DELETE FROM `ai`.`balance`;
INSERT INTO `ai`.`balance` (`id`,`Account`,`money`,`CreateTime`,`completeTime`,`type`) VALUES (1, 'admin', '100', '2023-09-22 01:33:32', '2023-09-22 01:33:34', 'Paintbalance');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `ai`.`interface` WRITE;
DELETE FROM `ai`.`interface`;
INSERT INTO `ai`.`interface` (`id`,`interface`,`receive`,`return`) VALUES (1, '/User/login', '[\"Account\",\"pws\"]', '[\"username\",\"Account\",\"creatTime\",\"status\",\"token\",\"phoneNumber\",\"imageUrl\"]'),(2, '/User/registered', '[\"Account\",\r\n    \"pws\",\r\n    \"phoneNumber\",\r\n    \"code\",\r\n    \"iamgeUrl\"]', '[\"username\",\"Account\",\"creatTime\",\"status\",\"token\",\"phoneNumber\",\"imageUrl\"]');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `ai`.`packagelist` WRITE;
DELETE FROM `ai`.`packagelist`;
INSERT INTO `ai`.`packagelist` (`id`,`name`,`money`,`PayList`,`types`,`businessid`) VALUES (1, '100w-Token', '69.9', '[\"wx\",\"zfb\"]', 'Paintbalance', '{\"wx\":\"123456\",\"zfb\":\"13456\"}'),(2, '100次绘画', '69.9', '[\"wx\",\"zfb\"]', 'Chatbalance', '{\"wx\":\"123456\",\"zfb\":\"13456\"}');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `ai`.`userinfo` WRITE;
DELETE FROM `ai`.`userinfo`;
INSERT INTO `ai`.`userinfo` (`id`,`username`,`Account`,`paswrod`,`creatTime`,`status`,`token`,`phoneNumber`,`imageUrl`,`Paintbalance`,`Chatbalance`) VALUES (4, '新用户', 'admin', '123456', '2023-09-22 01:27:07', '1', 'YWIwNmEzMDYxNDI2MTNhZjdlZWM1OWI5MzIxYTY5OGM=', '18226625596', NULL, 0, 0);
UNLOCK TABLES;
COMMIT;
